Dataset statistics
| Number of variables | 23 |
|---|---|
| Number of observations | 196694 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 119 |
| Duplicate rows (%) | 0.1% |
| Total size in memory | 36.0 MiB |
| Average record size in memory | 192.0 B |
Variable types
| Categorical | 11 |
|---|---|
| DateTime | 2 |
| Text | 6 |
| Numeric | 4 |
Year has constant value "2022-23" | Constant |
Billing grp has constant value "LFS" | Constant |
Channel-1 has constant value "LFS" | Constant |
| Dataset has 119 (0.1%) duplicate rows | Duplicates |
Brand is highly imbalanced (96.2%) | Imbalance |
Channel is highly imbalanced (50.9%) | Imbalance |
Quantity is highly skewed (γ1 = 36.44210692) | Skewed |
Reproduction
| Analysis started | 2024-05-27 06:16:19.899104 |
|---|---|
| Analysis finished | 2024-05-27 06:16:32.258979 |
| Duration | 12.36 seconds |
| Software version | ydata-profiling v4.8.3 |
| Download configuration | config.json |
Year
Categorical
CONSTANT 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| 2022-23 |
|---|
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 7 |
| Min length | 7 |
Characters and Unicode
| Total characters | 1376858 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2022-23 |
|---|---|
| 2nd row | 2022-23 |
| 3rd row | 2022-23 |
| 4th row | 2022-23 |
| 5th row | 2022-23 |
Common Values
| Value | Count | Frequency (%) |
| 2022-23 | 196694 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2022-23 | 196694 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 786776 | |
| 0 | 196694 | 14.3% |
| - | 196694 | 14.3% |
| 3 | 196694 | 14.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1180164 | |
| Dash Punctuation | 196694 | 14.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 786776 | |
| 0 | 196694 | 16.7% |
| 3 | 196694 | 16.7% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 196694 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1376858 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 786776 | |
| 0 | 196694 | 14.3% |
| - | 196694 | 14.3% |
| 3 | 196694 | 14.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1376858 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 786776 | |
| 0 | 196694 | 14.3% |
| - | 196694 | 14.3% |
| 3 | 196694 | 14.3% |
Month
Date
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| Minimum | 2022-04-01 00:00:00 |
|---|---|
| Maximum | 2023-03-01 00:00:00 |
Month Key
Categorical
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| Dec | |
|---|---|
| Oct | |
| Jan | |
| Aug | |
| Apr | |
| Other values (7) |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 590082 |
|---|---|
| Distinct characters | 22 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Apr |
|---|---|
| 2nd row | Apr |
| 3rd row | Apr |
| 4th row | Apr |
| 5th row | Apr |
Common Values
| Value | Count | Frequency (%) |
| Dec | 21326 | |
| Oct | 20032 | |
| Jan | 17202 | |
| Aug | 16414 | |
| Apr | 16315 | |
| May | 16039 | |
| Jul | 15940 | |
| Nov | 15129 | |
| Jun | 14894 | |
| Feb | 14824 | |
| Other values (2) | 28579 |
Length
| Value | Count | Frequency (%) |
| dec | 21326 | |
| oct | 20032 | |
| jan | 17202 | |
| aug | 16414 | |
| apr | 16315 | |
| may | 16039 | |
| jul | 15940 | |
| nov | 15129 | |
| jun | 14894 | |
| feb | 14824 | |
| Other values (2) | 28579 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 50933 | 8.6% |
| J | 48036 | 8.1% |
| u | 47248 | 8.0% |
| a | 47037 | 8.0% |
| c | 41358 | 7.0% |
| A | 32729 | 5.5% |
| n | 32096 | 5.4% |
| p | 31098 | 5.3% |
| r | 30111 | 5.1% |
| M | 29835 | 5.1% |
| Other values (12) | 199601 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 393388 | |
| Uppercase Letter | 196694 |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 50933 | |
| u | 47248 | |
| a | 47037 | |
| c | 41358 | |
| n | 32096 | |
| p | 31098 | |
| r | 30111 | |
| t | 20032 | 5.1% |
| g | 16414 | 4.2% |
| y | 16039 | 4.1% |
| Other values (4) | 61022 |
Uppercase Letter
| Value | Count | Frequency (%) |
| J | 48036 | |
| A | 32729 | |
| M | 29835 | |
| D | 21326 | |
| O | 20032 | |
| N | 15129 | 7.7% |
| F | 14824 | 7.5% |
| S | 14783 | 7.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 590082 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 50933 | 8.6% |
| J | 48036 | 8.1% |
| u | 47248 | 8.0% |
| a | 47037 | 8.0% |
| c | 41358 | 7.0% |
| A | 32729 | 5.5% |
| n | 32096 | 5.4% |
| p | 31098 | 5.3% |
| r | 30111 | 5.1% |
| M | 29835 | 5.1% |
| Other values (12) | 199601 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 590082 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 50933 | 8.6% |
| J | 48036 | 8.1% |
| u | 47248 | 8.0% |
| a | 47037 | 8.0% |
| c | 41358 | 7.0% |
| A | 32729 | 5.5% |
| n | 32096 | 5.4% |
| p | 31098 | 5.3% |
| r | 30111 | 5.1% |
| M | 29835 | 5.1% |
| Other values (12) | 199601 |
QTR
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| Q3 | |
|---|---|
| Q1 | |
| Q2 | |
| Q4 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 393388 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Q1 |
|---|---|
| 2nd row | Q1 |
| 3rd row | Q1 |
| 4th row | Q1 |
| 5th row | Q1 |
Common Values
| Value | Count | Frequency (%) |
| Q3 | 56487 | |
| Q1 | 47248 | |
| Q2 | 47137 | |
| Q4 | 45822 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| q3 | 56487 | |
| q1 | 47248 | |
| q2 | 47137 | |
| q4 | 45822 |
Most occurring characters
| Value | Count | Frequency (%) |
| Q | 196694 | |
| 3 | 56487 | 14.4% |
| 1 | 47248 | 12.0% |
| 2 | 47137 | 12.0% |
| 4 | 45822 | 11.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 196694 | |
| Decimal Number | 196694 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 56487 | |
| 1 | 47248 | |
| 2 | 47137 | |
| 4 | 45822 |
Uppercase Letter
| Value | Count | Frequency (%) |
| Q | 196694 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 196694 | |
| Common | 196694 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 3 | 56487 | |
| 1 | 47248 | |
| 2 | 47137 | |
| 4 | 45822 |
Latin
| Value | Count | Frequency (%) |
| Q | 196694 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 393388 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| Q | 196694 | |
| 3 | 56487 | 14.4% |
| 1 | 47248 | 12.0% |
| 2 | 47137 | 12.0% |
| 4 | 45822 | 11.6% |
Region
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| West | |
|---|---|
| South | |
| North | |
| East |
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 4.5140675 |
| Min length | 4 |
Characters and Unicode
| Total characters | 887890 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | South |
|---|---|
| 2nd row | South |
| 3rd row | South |
| 4th row | West |
| 5th row | South |
Common Values
| Value | Count | Frequency (%) |
| West | 59189 | |
| South | 51280 | |
| North | 49834 | |
| East | 36391 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| west | 59189 | |
| south | 51280 | |
| north | 49834 | |
| east | 36391 |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 196694 | |
| o | 101114 | |
| h | 101114 | |
| s | 95580 | |
| W | 59189 | 6.7% |
| e | 59189 | 6.7% |
| S | 51280 | 5.8% |
| u | 51280 | 5.8% |
| N | 49834 | 5.6% |
| r | 49834 | 5.6% |
| Other values (2) | 72782 | 8.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 691196 | |
| Uppercase Letter | 196694 | 22.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 196694 | |
| o | 101114 | |
| h | 101114 | |
| s | 95580 | |
| e | 59189 | 8.6% |
| u | 51280 | 7.4% |
| r | 49834 | 7.2% |
| a | 36391 | 5.3% |
Uppercase Letter
| Value | Count | Frequency (%) |
| W | 59189 | |
| S | 51280 | |
| N | 49834 | |
| E | 36391 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 887890 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| t | 196694 | |
| o | 101114 | |
| h | 101114 | |
| s | 95580 | |
| W | 59189 | 6.7% |
| e | 59189 | 6.7% |
| S | 51280 | 5.8% |
| u | 51280 | 5.8% |
| N | 49834 | 5.6% |
| r | 49834 | 5.6% |
| Other values (2) | 72782 | 8.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 887890 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| t | 196694 | |
| o | 101114 | |
| h | 101114 | |
| s | 95580 | |
| W | 59189 | 6.7% |
| e | 59189 | 6.7% |
| S | 51280 | 5.8% |
| u | 51280 | 5.8% |
| N | 49834 | 5.6% |
| r | 49834 | 5.6% |
| Other values (2) | 72782 | 8.2% |
Invoice Date
Date
| Distinct | 365 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| Minimum | 2022-04-01 00:00:00 |
|---|---|
| Maximum | 2023-03-31 00:00:00 |
Material
Text
| Distinct | 173 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
Length
| Max length | 10 |
|---|---|
| Median length | 9 |
| Mean length | 8.6216102 |
| Min length | 7 |
Characters and Unicode
| Total characters | 1695819 |
|---|---|
| Distinct characters | 25 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 11 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | NFM03DQ1 |
|---|---|
| 2nd row | NDFM13PD1 |
| 3rd row | NFM05DQ1 |
| 4th row | FW19PC1 |
| 5th row | NEFW05PGC |
| Value | Count | Frequency (%) |
| nfm01dq1 | 9526 | 4.8% |
| nffm01pgc | 8053 | 4.1% |
| nffm01cl2 | 7357 | 3.7% |
| nffw01cl2 | 6961 | 3.5% |
| nfw01dq1 | 6572 | 3.3% |
| nefw11pd1 | 6542 | 3.3% |
| nfm05dq1 | 6485 | 3.3% |
| nffm14ph1 | 5938 | 3.0% |
| nffw02pfc | 5850 | 3.0% |
| nfm03dq1 | 5800 | 2.9% |
| Other values (163) | 127610 |
Most occurring characters
| Value | Count | Frequency (%) |
| F | 303252 | |
| 1 | 234866 | |
| N | 180238 | |
| P | 142292 | |
| 0 | 138853 | |
| M | 104870 | 6.2% |
| W | 82788 | 4.9% |
| D | 81389 | 4.8% |
| C | 75575 | 4.5% |
| 2 | 69708 | 4.1% |
| Other values (15) | 281988 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1156666 | |
| Decimal Number | 539153 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| F | 303252 | |
| N | 180238 | |
| P | 142292 | |
| M | 104870 | 9.1% |
| W | 82788 | 7.2% |
| D | 81389 | 7.0% |
| C | 75575 | 6.5% |
| Q | 48680 | 4.2% |
| G | 44476 | 3.8% |
| E | 42386 | 3.7% |
| Other values (5) | 50720 | 4.4% |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 234866 | |
| 0 | 138853 | |
| 2 | 69708 | 12.9% |
| 4 | 35642 | 6.6% |
| 3 | 23924 | 4.4% |
| 5 | 18243 | 3.4% |
| 9 | 5761 | 1.1% |
| 8 | 5098 | 0.9% |
| 6 | 4442 | 0.8% |
| 7 | 2616 | 0.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1156666 | |
| Common | 539153 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| F | 303252 | |
| N | 180238 | |
| P | 142292 | |
| M | 104870 | 9.1% |
| W | 82788 | 7.2% |
| D | 81389 | 7.0% |
| C | 75575 | 6.5% |
| Q | 48680 | 4.2% |
| G | 44476 | 3.8% |
| E | 42386 | 3.7% |
| Other values (5) | 50720 | 4.4% |
Common
| Value | Count | Frequency (%) |
| 1 | 234866 | |
| 0 | 138853 | |
| 2 | 69708 | 12.9% |
| 4 | 35642 | 6.6% |
| 3 | 23924 | 4.4% |
| 5 | 18243 | 3.4% |
| 9 | 5761 | 1.1% |
| 8 | 5098 | 0.9% |
| 6 | 4442 | 0.8% |
| 7 | 2616 | 0.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1695819 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| F | 303252 | |
| 1 | 234866 | |
| N | 180238 | |
| P | 142292 | |
| 0 | 138853 | |
| M | 104870 | 6.2% |
| W | 82788 | 4.9% |
| D | 81389 | 4.8% |
| C | 75575 | 4.5% |
| 2 | 69708 | 4.1% |
| Other values (15) | 281988 |
Quantity
Real number (ℝ)
SKEWED 
| Distinct | 40 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.1904125 |
| Minimum | -18 |
|---|---|
| Maximum | 142 |
| Zeros | 8 |
| Zeros (%) | < 0.1% |
| Negative | 593 |
| Negative (%) | 0.3% |
| Memory size | 3.0 MiB |
Quantile statistics
| Minimum | -18 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 142 |
| Range | 160 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.84269779 |
|---|---|
| Coefficient of variation (CV) | 0.707904 |
| Kurtosis | 4503.3313 |
| Mean | 1.1904125 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 36.442107 |
| Sum | 234147 |
| Variance | 0.71013956 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 170447 | |
| 2 | 19461 | 9.9% |
| 3 | 3804 | 1.9% |
| 4 | 1169 | 0.6% |
| -1 | 570 | 0.3% |
| 5 | 456 | 0.2% |
| 6 | 256 | 0.1% |
| 7 | 153 | 0.1% |
| 8 | 88 | < 0.1% |
| 10 | 51 | < 0.1% |
| Other values (30) | 239 | 0.1% |
| Value | Count | Frequency (%) |
| -18 | 1 | < 0.1% |
| -3 | 3 | < 0.1% |
| -2 | 19 | < 0.1% |
| -1 | 570 | 0.3% |
| 0 | 8 | < 0.1% |
| 1 | 170447 | |
| 2 | 19461 | 9.9% |
| 3 | 3804 | 1.9% |
| 4 | 1169 | 0.6% |
| 5 | 456 | 0.2% |
| Value | Count | Frequency (%) |
| 142 | 1 | < 0.1% |
| 75 | 1 | < 0.1% |
| 45 | 1 | < 0.1% |
| 42 | 2 | |
| 37 | 1 | < 0.1% |
| 33 | 1 | < 0.1% |
| 30 | 1 | < 0.1% |
| 28 | 1 | < 0.1% |
| 27 | 2 | |
| 26 | 3 |
Gender
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| G | |
|---|---|
| L | |
| P | 8813 |
| U | 295 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 196694 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | G |
|---|---|
| 2nd row | G |
| 3rd row | G |
| 4th row | L |
| 5th row | L |
Common Values
| Value | Count | Frequency (%) |
| G | 104832 | |
| L | 82754 | |
| P | 8813 | 4.5% |
| U | 295 | 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| g | 104832 | |
| l | 82754 | |
| p | 8813 | 4.5% |
| u | 295 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| G | 104832 | |
| L | 82754 | |
| P | 8813 | 4.5% |
| U | 295 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 196694 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| G | 104832 | |
| L | 82754 | |
| P | 8813 | 4.5% |
| U | 295 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 196694 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| G | 104832 | |
| L | 82754 | |
| P | 8813 | 4.5% |
| U | 295 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 196694 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| G | 104832 | |
| L | 82754 | |
| P | 8813 | 4.5% |
| U | 295 | 0.1% |
Brand
Categorical
IMBALANCE 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| TF | |
|---|---|
| FP | 807 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 393388 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | TF |
|---|---|
| 2nd row | TF |
| 3rd row | TF |
| 4th row | TF |
| 5th row | TF |
Common Values
| Value | Count | Frequency (%) |
| TF | 195887 | |
| FP | 807 | 0.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| tf | 195887 | |
| fp | 807 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| F | 196694 | |
| T | 195887 | |
| P | 807 | 0.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 393388 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| F | 196694 | |
| T | 195887 | |
| P | 807 | 0.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 393388 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| F | 196694 | |
| T | 195887 | |
| P | 807 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 393388 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| F | 196694 | |
| T | 195887 | |
| P | 807 | 0.2% |
Channel
Categorical
IMBALANCE 
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| SS | |
|---|---|
| LS | |
| PT | 8173 |
| CT | 3992 |
| RRL | 1007 |
| Other values (2) | 294 |
Length
| Max length | 3 |
|---|---|
| Median length | 2 |
| Mean length | 2.0051196 |
| Min length | 2 |
Characters and Unicode
| Total characters | 394395 |
|---|---|
| Distinct characters | 8 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | CN |
|---|---|
| 2nd row | CN |
| 3rd row | CN |
| 4th row | CN |
| 5th row | CN |
Common Values
| Value | Count | Frequency (%) |
| SS | 101176 | |
| LS | 82052 | |
| PT | 8173 | 4.2% |
| CT | 3992 | 2.0% |
| RRL | 1007 | 0.5% |
| CN | 263 | 0.1% |
| ss | 31 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| ss | 101207 | |
| ls | 82052 | |
| pt | 8173 | 4.2% |
| ct | 3992 | 2.0% |
| rrl | 1007 | 0.5% |
| cn | 263 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 284404 | |
| L | 83059 | 21.1% |
| T | 12165 | 3.1% |
| P | 8173 | 2.1% |
| C | 4255 | 1.1% |
| R | 2014 | 0.5% |
| N | 263 | 0.1% |
| s | 62 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 394333 | |
| Lowercase Letter | 62 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 284404 | |
| L | 83059 | 21.1% |
| T | 12165 | 3.1% |
| P | 8173 | 2.1% |
| C | 4255 | 1.1% |
| R | 2014 | 0.5% |
| N | 263 | 0.1% |
Lowercase Letter
| Value | Count | Frequency (%) |
| s | 62 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 394395 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| S | 284404 | |
| L | 83059 | 21.1% |
| T | 12165 | 3.1% |
| P | 8173 | 2.1% |
| C | 4255 | 1.1% |
| R | 2014 | 0.5% |
| N | 263 | 0.1% |
| s | 62 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 394395 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| S | 284404 | |
| L | 83059 | 21.1% |
| T | 12165 | 3.1% |
| P | 8173 | 2.1% |
| C | 4255 | 1.1% |
| R | 2014 | 0.5% |
| N | 263 | 0.1% |
| s | 62 | < 0.1% |
Franchisee store
Text
| Distinct | 311 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
Length
| Max length | 7 |
|---|---|
| Median length | 5 |
| Mean length | 5.0688481 |
| Min length | 5 |
Characters and Unicode
| Total characters | 997012 |
|---|---|
| Distinct characters | 18 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | CN1200 |
|---|---|
| 2nd row | CN1201 |
| 3rd row | CN1201 |
| 4th row | CN1206 |
| 5th row | CN1212 |
| Value | Count | Frequency (%) |
| ss222 | 4592 | 2.3% |
| ls751 | 3802 | 1.9% |
| ss223 | 3746 | 1.9% |
| ls760 | 3497 | 1.8% |
| ss283 | 2636 | 1.3% |
| ls758 | 2541 | 1.3% |
| ss255 | 2540 | 1.3% |
| ss209 | 2451 | 1.2% |
| ls741 | 2232 | 1.1% |
| ss219 | 2227 | 1.1% |
| Other values (301) | 166430 |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 284467 | |
| 2 | 132830 | |
| 7 | 108833 | 10.9% |
| L | 83058 | 8.3% |
| 3 | 72067 | 7.2% |
| 1 | 65368 | 6.6% |
| 0 | 54012 | 5.4% |
| 8 | 36263 | 3.6% |
| 5 | 35985 | 3.6% |
| 4 | 34098 | 3.4% |
| Other values (8) | 90031 | 9.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 602613 | |
| Uppercase Letter | 394399 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 132830 | |
| 7 | 108833 | |
| 3 | 72067 | |
| 1 | 65368 | |
| 0 | 54012 | |
| 8 | 36263 | 6.0% |
| 5 | 35985 | 6.0% |
| 4 | 34098 | 5.7% |
| 9 | 31814 | 5.3% |
| 6 | 31343 | 5.2% |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 284467 | |
| L | 83058 | 21.1% |
| T | 12167 | 3.1% |
| P | 8173 | 2.1% |
| C | 4255 | 1.1% |
| R | 2014 | 0.5% |
| N | 263 | 0.1% |
| O | 2 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 602613 | |
| Latin | 394399 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 132830 | |
| 7 | 108833 | |
| 3 | 72067 | |
| 1 | 65368 | |
| 0 | 54012 | |
| 8 | 36263 | 6.0% |
| 5 | 35985 | 6.0% |
| 4 | 34098 | 5.7% |
| 9 | 31814 | 5.3% |
| 6 | 31343 | 5.2% |
Latin
| Value | Count | Frequency (%) |
| S | 284467 | |
| L | 83058 | 21.1% |
| T | 12167 | 3.1% |
| P | 8173 | 2.1% |
| C | 4255 | 1.1% |
| R | 2014 | 0.5% |
| N | 263 | 0.1% |
| O | 2 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 997012 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| S | 284467 | |
| 2 | 132830 | |
| 7 | 108833 | 10.9% |
| L | 83058 | 8.3% |
| 3 | 72067 | 7.2% |
| 1 | 65368 | 6.6% |
| 0 | 54012 | 5.4% |
| 8 | 36263 | 3.6% |
| 5 | 35985 | 3.6% |
| 4 | 34098 | 3.4% |
| Other values (8) | 90031 | 9.0% |
| Distinct | 311 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
Length
| Max length | 7 |
|---|---|
| Median length | 5 |
| Mean length | 5.0688481 |
| Min length | 5 |
Characters and Unicode
| Total characters | 997012 |
|---|---|
| Distinct characters | 18 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | CN1200 |
|---|---|
| 2nd row | CN1201 |
| 3rd row | CN1201 |
| 4th row | CN1206 |
| 5th row | CN1212 |
| Value | Count | Frequency (%) |
| ss222 | 4592 | 2.3% |
| ls751 | 3802 | 1.9% |
| ss223 | 3746 | 1.9% |
| ls760 | 3497 | 1.8% |
| ss283 | 2636 | 1.3% |
| ls758 | 2541 | 1.3% |
| ss255 | 2540 | 1.3% |
| ss209 | 2451 | 1.2% |
| ls741 | 2232 | 1.1% |
| ss219 | 2227 | 1.1% |
| Other values (301) | 166430 |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 284467 | |
| 2 | 132830 | |
| 7 | 108833 | 10.9% |
| L | 83058 | 8.3% |
| 3 | 72067 | 7.2% |
| 1 | 65368 | 6.6% |
| 0 | 54012 | 5.4% |
| 8 | 36263 | 3.6% |
| 5 | 35985 | 3.6% |
| 4 | 34098 | 3.4% |
| Other values (8) | 90031 | 9.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 602613 | |
| Uppercase Letter | 394399 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 132830 | |
| 7 | 108833 | |
| 3 | 72067 | |
| 1 | 65368 | |
| 0 | 54012 | |
| 8 | 36263 | 6.0% |
| 5 | 35985 | 6.0% |
| 4 | 34098 | 5.7% |
| 9 | 31814 | 5.3% |
| 6 | 31343 | 5.2% |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 284467 | |
| L | 83058 | 21.1% |
| T | 12167 | 3.1% |
| P | 8173 | 2.1% |
| C | 4255 | 1.1% |
| R | 2014 | 0.5% |
| N | 263 | 0.1% |
| O | 2 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 602613 | |
| Latin | 394399 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 132830 | |
| 7 | 108833 | |
| 3 | 72067 | |
| 1 | 65368 | |
| 0 | 54012 | |
| 8 | 36263 | 6.0% |
| 5 | 35985 | 6.0% |
| 4 | 34098 | 5.7% |
| 9 | 31814 | 5.3% |
| 6 | 31343 | 5.2% |
Latin
| Value | Count | Frequency (%) |
| S | 284467 | |
| L | 83058 | 21.1% |
| T | 12167 | 3.1% |
| P | 8173 | 2.1% |
| C | 4255 | 1.1% |
| R | 2014 | 0.5% |
| N | 263 | 0.1% |
| O | 2 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 997012 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| S | 284467 | |
| 2 | 132830 | |
| 7 | 108833 | 10.9% |
| L | 83058 | 8.3% |
| 3 | 72067 | 7.2% |
| 1 | 65368 | 6.6% |
| 0 | 54012 | 5.4% |
| 8 | 36263 | 3.6% |
| 5 | 35985 | 3.6% |
| 4 | 34098 | 3.4% |
| Other values (8) | 90031 | 9.0% |
| Distinct | 495 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
Length
| Max length | 42 |
|---|---|
| Median length | 34 |
| Mean length | 19.890129 |
| Min length | 7 |
Characters and Unicode
| Total characters | 3912269 |
|---|---|
| Distinct characters | 70 |
| Distinct categories | 8 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 9 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | CT-BENGALURU-RESIDENCYROAD |
|---|---|
| 2nd row | CT-HYDERABAD-G.S.CENTERPOINT |
| 3rd row | CT-HYDERABAD-G.S.CENTERPOINT |
| 4th row | CT-MUMBAI-GOREGAON-OBEROIMALL |
| 5th row | CT-BENGALURU-J.P.NAGAR |
| Value | Count | Frequency (%) |
| 10445 | 3.5% | |
| city | 6054 | 2.0% |
| mall | 4504 | 1.5% |
| kolkata | 4487 | 1.5% |
| ls | 3230 | 1.1% |
| 115-ssl-saltlakekolkata | 3219 | 1.1% |
| phoenix | 3088 | 1.0% |
| market | 3027 | 1.0% |
| lsdlfmall-noida | 2557 | 0.9% |
| 128-ssl-southcitykolkata | 2514 | 0.9% |
| Other values (725) | 252501 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 323272 | 8.3% |
| S | 297250 | 7.6% |
| L | 242906 | 6.2% |
| A | 242844 | 6.2% |
| a | 190404 | 4.9% |
| T | 113059 | 2.9% |
| R | 109736 | 2.8% |
| l | 100342 | 2.6% |
| 97900 | 2.5% | |
| e | 97295 | 2.5% |
| Other values (60) | 2097261 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 2069465 | |
| Lowercase Letter | 1098598 | |
| Dash Punctuation | 323272 | 8.3% |
| Decimal Number | 314695 | 8.0% |
| Space Separator | 98936 | 2.5% |
| Open Punctuation | 3220 | 0.1% |
| Close Punctuation | 3220 | 0.1% |
| Other Punctuation | 863 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 297250 | |
| L | 242906 | |
| A | 242844 | |
| T | 113059 | 5.5% |
| R | 109736 | 5.3% |
| N | 96098 | 4.6% |
| O | 93824 | 4.5% |
| M | 92428 | 4.5% |
| I | 90853 | 4.4% |
| C | 83882 | 4.1% |
| Other values (16) | 606585 |
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 190404 | |
| l | 100342 | 9.1% |
| e | 97295 | 8.9% |
| i | 92417 | 8.4% |
| r | 78042 | 7.1% |
| n | 77716 | 7.1% |
| t | 65706 | 6.0% |
| o | 61247 | 5.6% |
| h | 44585 | 4.1% |
| u | 38932 | 3.5% |
| Other values (16) | 251912 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 93732 | |
| 2 | 46618 | |
| 4 | 30890 | 9.8% |
| 5 | 29694 | 9.4% |
| 8 | 23274 | 7.4% |
| 6 | 19419 | 6.2% |
| 9 | 18480 | 5.9% |
| 7 | 18320 | 5.8% |
| 3 | 18110 | 5.8% |
| 0 | 16158 | 5.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| & | 638 | |
| . | 204 | 23.6% |
| , | 21 | 2.4% |
Space Separator
| Value | Count | Frequency (%) |
| 97900 | ||
| Â | 1036 | 1.0% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 323272 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 3220 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 3220 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 3168063 | |
| Common | 744206 | 19.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| S | 297250 | 9.4% |
| L | 242906 | 7.7% |
| A | 242844 | 7.7% |
| a | 190404 | 6.0% |
| T | 113059 | 3.6% |
| R | 109736 | 3.5% |
| l | 100342 | 3.2% |
| e | 97295 | 3.1% |
| N | 96098 | 3.0% |
| O | 93824 | 3.0% |
| Other values (42) | 1584305 |
Common
| Value | Count | Frequency (%) |
| - | 323272 | |
| 97900 | 13.2% | |
| 1 | 93732 | 12.6% |
| 2 | 46618 | 6.3% |
| 4 | 30890 | 4.2% |
| 5 | 29694 | 4.0% |
| 8 | 23274 | 3.1% |
| 6 | 19419 | 2.6% |
| 9 | 18480 | 2.5% |
| 7 | 18320 | 2.5% |
| Other values (8) | 42607 | 5.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3911233 | |
| None | 1036 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| - | 323272 | 8.3% |
| S | 297250 | 7.6% |
| L | 242906 | 6.2% |
| A | 242844 | 6.2% |
| a | 190404 | 4.9% |
| T | 113059 | 2.9% |
| R | 109736 | 2.8% |
| l | 100342 | 2.6% |
| 97900 | 2.5% | |
| e | 97295 | 2.5% |
| Other values (59) | 2096225 |
None
| Value | Count | Frequency (%) |
| Â | 1036 |
MRP
Real number (ℝ)
| Distinct | 34 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1631.6023 |
| Minimum | 399 |
|---|---|
| Maximum | 4995 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.0 MiB |
Quantile statistics
| Minimum | 399 |
|---|---|
| 5-th percentile | 499 |
| Q1 | 595 |
| median | 1595 |
| Q3 | 2495 |
| 95-th percentile | 3095 |
| Maximum | 4995 |
| Range | 4596 |
| Interquartile range (IQR) | 1900 |
Descriptive statistics
| Standard deviation | 995.23332 |
|---|---|
| Coefficient of variation (CV) | 0.609973 |
| Kurtosis | -0.56123143 |
| Mean | 1631.6023 |
| Median Absolute Deviation (MAD) | 1000 |
| Skewness | 0.41288003 |
| Sum | 3.2092637 × 108 |
| Variance | 990489.36 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 499 | 47180 | |
| 1995 | 24104 | |
| 2595 | 23515 | |
| 645 | 23482 | |
| 1595 | 20119 | |
| 1895 | 8738 | 4.4% |
| 2695 | 8717 | 4.4% |
| 2295 | 8446 | 4.3% |
| 3995 | 6358 | 3.2% |
| 595 | 4599 | 2.3% |
| Other values (24) | 21436 |
| Value | Count | Frequency (%) |
| 399 | 181 | 0.1% |
| 499 | 47180 | |
| 545 | 231 | 0.1% |
| 595 | 4599 | 2.3% |
| 645 | 23482 | |
| 845 | 681 | 0.3% |
| 895 | 167 | 0.1% |
| 1195 | 13 | < 0.1% |
| 1295 | 26 | < 0.1% |
| 1345 | 1588 | 0.8% |
| Value | Count | Frequency (%) |
| 4995 | 33 | < 0.1% |
| 4795 | 197 | 0.1% |
| 4590 | 794 | 0.4% |
| 4190 | 411 | 0.2% |
| 3995 | 6358 | 3.2% |
| 3095 | 2142 | 1.1% |
| 2995 | 4287 | 2.2% |
| 2795 | 1548 | 0.8% |
| 2695 | 8717 | 4.4% |
| 2595 | 23515 |
Gross UCP
Real number (ℝ)
| Distinct | 246 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1920.3982 |
| Minimum | -28710 |
|---|---|
| Maximum | 142125 |
| Zeros | 8 |
| Zeros (%) | < 0.1% |
| Negative | 593 |
| Negative (%) | 0.3% |
| Memory size | 3.0 MiB |
Quantile statistics
| Minimum | -28710 |
|---|---|
| 5-th percentile | 499 |
| Q1 | 645 |
| median | 1895 |
| Q3 | 2595 |
| 95-th percentile | 4590 |
| Maximum | 142125 |
| Range | 170835 |
| Interquartile range (IQR) | 1950 |
Descriptive statistics
| Standard deviation | 1771.1415 |
|---|---|
| Coefficient of variation (CV) | 0.92227824 |
| Kurtosis | 592.61172 |
| Mean | 1920.3982 |
| Median Absolute Deviation (MAD) | 897 |
| Skewness | 11.699347 |
| Sum | 3.7773081 × 108 |
| Variance | 3136942.2 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 499 | 40157 | |
| 645 | 20758 | |
| 1995 | 20744 | |
| 2595 | 20518 | |
| 1595 | 15517 | 7.9% |
| 2295 | 7777 | 4.0% |
| 2695 | 7765 | 3.9% |
| 1895 | 7731 | 3.9% |
| 3995 | 5789 | 2.9% |
| 998 | 5583 | 2.8% |
| Other values (236) | 44355 |
| Value | Count | Frequency (%) |
| -28710 | 1 | < 0.1% |
| -11985 | 1 | < 0.1% |
| -7990 | 1 | < 0.1% |
| -5990 | 1 | < 0.1% |
| -5390 | 2 | < 0.1% |
| -4990 | 1 | < 0.1% |
| -4795 | 1 | < 0.1% |
| -4590 | 4 | < 0.1% |
| -4190 | 3 | < 0.1% |
| -3995 | 27 |
| Value | Count | Frequency (%) |
| 142125 | 1 | |
| 134775 | 1 | |
| 125790 | 1 | |
| 91590 | 1 | |
| 66990 | 1 | |
| 59900 | 1 | |
| 59670 | 1 | |
| 59015 | 1 | |
| 52635 | 1 | |
| 47880 | 1 |
Net UCP
Real number (ℝ)
| Distinct | 3643 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1749.921 |
| Minimum | -17982 |
|---|---|
| Maximum | 127912.5 |
| Zeros | 885 |
| Zeros (%) | 0.4% |
| Negative | 590 |
| Negative (%) | 0.3% |
| Memory size | 3.0 MiB |
Quantile statistics
| Minimum | -17982 |
|---|---|
| 5-th percentile | 449.5 |
| Q1 | 645 |
| median | 1695.75 |
| Q3 | 2335.5 |
| 95-th percentile | 3995 |
| Maximum | 127912.5 |
| Range | 145894.5 |
| Interquartile range (IQR) | 1690.5 |
Descriptive statistics
| Standard deviation | 1488.0559 |
|---|---|
| Coefficient of variation (CV) | 0.85035608 |
| Kurtosis | 597.84683 |
| Mean | 1749.921 |
| Median Absolute Deviation (MAD) | 899.25 |
| Skewness | 10.525224 |
| Sum | 3.4419896 × 108 |
| Variance | 2214310.5 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 499 | 30691 | 15.6% |
| 645 | 18774 | 9.5% |
| 2595 | 11690 | 5.9% |
| 1995 | 11003 | 5.6% |
| 1595 | 9654 | 4.9% |
| 1895 | 5675 | 2.9% |
| 999 | 5548 | 2.8% |
| 1695.75 | 5125 | 2.6% |
| 2295 | 4947 | 2.5% |
| 3995 | 4918 | 2.5% |
| Other values (3633) | 88669 |
| Value | Count | Frequency (%) |
| -17982 | 1 | < 0.1% |
| -11985 | 1 | < 0.1% |
| -7990 | 1 | < 0.1% |
| -5091.5 | 1 | < 0.1% |
| -4795 | 1 | < 0.1% |
| -4590 | 2 | < 0.1% |
| -4390 | 2 | < 0.1% |
| -4190 | 3 | < 0.1% |
| -3995 | 25 | |
| -3992 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 127912.5 | 1 | |
| 107820 | 1 | |
| 106921.5 | 1 | |
| 78045 | 1 | |
| 50915 | 1 | |
| 47736 | 1 | |
| 43890 | 1 | |
| 43092 | 1 | |
| 41958 | 1 | |
| 36963 | 1 |
| Distinct | 97 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
Length
| Max length | 20 |
|---|---|
| Median length | 17 |
| Mean length | 6.8919184 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1355599 |
|---|---|
| Distinct characters | 50 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Bangalore |
|---|---|
| 2nd row | Hyderabad |
| 3rd row | Hyderabad |
| 4th row | Mumbai |
| 5th row | Bangalore |
| Value | Count | Frequency (%) |
| mumbai | 24938 | 12.7% |
| kolkata | 22125 | 11.2% |
| bangalore | 21733 | 11.0% |
| delhi | 14455 | 7.3% |
| pune | 12677 | 6.4% |
| hyderabad | 9323 | 4.7% |
| noida | 9242 | 4.7% |
| chennai | 6603 | 3.4% |
| gurgaon | 5701 | 2.9% |
| lucknow | 4688 | 2.4% |
| Other values (87) | 65361 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 244292 | |
| i | 86769 | 6.4% |
| o | 83624 | 6.2% |
| e | 81597 | 6.0% |
| n | 79925 | 5.9% |
| r | 78039 | 5.8% |
| u | 77605 | 5.7% |
| l | 68626 | 5.1% |
| d | 50838 | 3.8% |
| h | 49576 | 3.7% |
| Other values (40) | 454708 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1148117 | |
| Uppercase Letter | 202701 | 15.0% |
| Space Separator | 1746 | 0.1% |
| Decimal Number | 1260 | 0.1% |
| Dash Punctuation | 935 | 0.1% |
| Open Punctuation | 420 | < 0.1% |
| Close Punctuation | 420 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 244292 | |
| i | 86769 | 7.6% |
| o | 83624 | 7.3% |
| e | 81597 | 7.1% |
| n | 79925 | 7.0% |
| r | 78039 | 6.8% |
| u | 77605 | 6.8% |
| l | 68626 | 6.0% |
| d | 50838 | 4.4% |
| h | 49576 | 4.3% |
| Other values (13) | 247226 |
Uppercase Letter
| Value | Count | Frequency (%) |
| B | 29163 | |
| M | 28526 | |
| K | 25402 | |
| D | 17011 | |
| P | 15364 | |
| G | 14217 | |
| N | 12291 | 6.1% |
| C | 12057 | 5.9% |
| H | 10380 | 5.1% |
| A | 7288 | 3.6% |
| Other values (10) | 31002 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 420 | |
| 3 | 420 | |
| 0 | 420 |
Space Separator
| Value | Count | Frequency (%) |
| 1746 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 935 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 420 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 420 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1350818 | |
| Common | 4781 | 0.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 244292 | |
| i | 86769 | 6.4% |
| o | 83624 | 6.2% |
| e | 81597 | 6.0% |
| n | 79925 | 5.9% |
| r | 78039 | 5.8% |
| u | 77605 | 5.7% |
| l | 68626 | 5.1% |
| d | 50838 | 3.8% |
| h | 49576 | 3.7% |
| Other values (33) | 449927 |
Common
| Value | Count | Frequency (%) |
| 1746 | ||
| - | 935 | |
| ( | 420 | 8.8% |
| 2 | 420 | 8.8% |
| 3 | 420 | 8.8% |
| 0 | 420 | 8.8% |
| ) | 420 | 8.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1355599 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 244292 | |
| i | 86769 | 6.4% |
| o | 83624 | 6.2% |
| e | 81597 | 6.0% |
| n | 79925 | 5.9% |
| r | 78039 | 5.8% |
| u | 77605 | 5.7% |
| l | 68626 | 5.1% |
| d | 50838 | 3.8% |
| h | 49576 | 3.7% |
| Other values (40) | 454708 |
ShiptopartyStateCode
Categorical
| Distinct | 30 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| MAHARASTRA | |
|---|---|
| WESTBENGAL | |
| KARNATAKA | |
| UTTARPRADESH | |
| DELHI | |
| Other values (25) |
Length
| Max length | 20 |
|---|---|
| Median length | 17 |
| Mean length | 10.877937 |
| Min length | 3 |
Characters and Unicode
| Total characters | 2139625 |
|---|---|
| Distinct characters | 36 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | KARNATAKA |
|---|---|
| 2nd row | TELANGANA |
| 3rd row | TELANGANA |
| 4th row | MAHARASTRA |
| 5th row | KARNATAKA |
Common Values
| Value | Count | Frequency (%) |
| MAHARASTRA | 44256 | |
| WESTBENGAL | 31145 | |
| KARNATAKA | 25078 | |
| UTTARPRADESH | 19320 | |
| DELHI | 15893 | 8.1% |
| TAMILNADU | 9179 | 4.7% |
| TELANGANA | 8510 | 4.3% |
| HARYANA | 8224 | 4.2% |
| GUJARAT | 7717 | 3.9% |
| MADHYA PRADESH | 6033 | 3.1% |
| Other values (20) | 21339 |
Length
| Value | Count | Frequency (%) |
| maharastra | 44256 | |
| westbengal | 31145 | |
| karnataka | 25078 | |
| uttarpradesh | 19320 | |
| delhi | 15893 | 7.7% |
| pradesh | 10126 | 4.9% |
| telangana | 9325 | 4.5% |
| tamilnadu | 9179 | 4.4% |
| haryana | 8224 | 4.0% |
| gujarat | 7717 | 3.7% |
| Other values (18) | 27077 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 492754 | |
| 317734 | ||
| R | 194225 | 9.1% |
| T | 172674 | 8.1% |
| H | 120084 | 5.6% |
| E | 118252 | 5.5% |
| S | 113252 | 5.3% |
| N | 103003 | 4.8% |
| L | 66988 | 3.1% |
| D | 66941 | 3.1% |
| Other values (26) | 373718 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1812537 | |
| Space Separator | 317734 | 14.8% |
| Lowercase Letter | 9094 | 0.4% |
| Other Punctuation | 260 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 492754 | |
| R | 194225 | 10.7% |
| T | 172674 | 9.5% |
| H | 120084 | 6.6% |
| E | 118252 | 6.5% |
| S | 113252 | 6.2% |
| N | 103003 | 5.7% |
| L | 66988 | 3.7% |
| D | 66941 | 3.7% |
| M | 61013 | 3.4% |
| Other values (11) | 303351 |
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 3302 | |
| n | 1708 | |
| l | 1134 | 12.5% |
| e | 1129 | 12.4% |
| g | 850 | 9.3% |
| r | 357 | 3.9% |
| h | 176 | 1.9% |
| o | 111 | 1.2% |
| d | 78 | 0.9% |
| u | 73 | 0.8% |
| Other values (3) | 176 | 1.9% |
Space Separator
| Value | Count | Frequency (%) |
| 317734 |
Other Punctuation
| Value | Count | Frequency (%) |
| & | 260 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1821631 | |
| Common | 317994 | 14.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 492754 | |
| R | 194225 | 10.7% |
| T | 172674 | 9.5% |
| H | 120084 | 6.6% |
| E | 118252 | 6.5% |
| S | 113252 | 6.2% |
| N | 103003 | 5.7% |
| L | 66988 | 3.7% |
| D | 66941 | 3.7% |
| M | 61013 | 3.3% |
| Other values (24) | 312445 |
Common
| Value | Count | Frequency (%) |
| 317734 | ||
| & | 260 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2139625 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 492754 | |
| 317734 | ||
| R | 194225 | 9.1% |
| T | 172674 | 8.1% |
| H | 120084 | 5.6% |
| E | 118252 | 5.5% |
| S | 113252 | 5.3% |
| N | 103003 | 4.8% |
| L | 66988 | 3.1% |
| D | 66941 | 3.1% |
| Other values (26) | 373718 |
Billing grp
Categorical
CONSTANT 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| LFS |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 590082 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | LFS |
|---|---|
| 2nd row | LFS |
| 3rd row | LFS |
| 4th row | LFS |
| 5th row | LFS |
Common Values
| Value | Count | Frequency (%) |
| LFS | 196694 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| lfs | 196694 |
Most occurring characters
| Value | Count | Frequency (%) |
| L | 196694 | |
| F | 196694 | |
| S | 196694 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 590082 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| L | 196694 | |
| F | 196694 | |
| S | 196694 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 590082 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| L | 196694 | |
| F | 196694 | |
| S | 196694 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 590082 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| L | 196694 | |
| F | 196694 | |
| S | 196694 |
Channel-1
Categorical
CONSTANT 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| LFS |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 590082 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | LFS |
|---|---|
| 2nd row | LFS |
| 3rd row | LFS |
| 4th row | LFS |
| 5th row | LFS |
Common Values
| Value | Count | Frequency (%) |
| LFS | 196694 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| lfs | 196694 |
Most occurring characters
| Value | Count | Frequency (%) |
| L | 196694 | |
| F | 196694 | |
| S | 196694 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 590082 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| L | 196694 | |
| F | 196694 | |
| S | 196694 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 590082 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| L | 196694 | |
| F | 196694 | |
| S | 196694 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 590082 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| L | 196694 | |
| F | 196694 | |
| S | 196694 |
Variant Name
Text
| Distinct | 65 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
Length
| Max length | 40 |
|---|---|
| Median length | 25 |
| Mean length | 17.565513 |
| Min length | 11 |
Characters and Unicode
| Total characters | 3455031 |
|---|---|
| Distinct characters | 61 |
| Distinct categories | 9 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 3. 150 M Amalfi Men deo |
|---|---|
| 2nd row | 3. 20 M Verge |
| 3rd row | 8. Deo M C. Road 150 ml |
| 4th row | 3. Tales W Ibiza 100 ml |
| 5th row | 7. 100 W Pristine |
| Value | Count | Frequency (%) |
| m | 111850 | 11.4% |
| w | 82781 | 8.5% |
| deo | 63370 | 6.5% |
| ml | 61898 | 6.3% |
| 100 | 58007 | 5.9% |
| 150 | 47361 | 4.8% |
| 1 | 44321 | 4.5% |
| raw | 32964 | 3.4% |
| 2 | 29844 | 3.1% |
| 3 | 29693 | 3.0% |
| Other values (69) | 415995 |
Most occurring characters
| Value | Count | Frequency (%) |
| 781390 | ||
| e | 296242 | 8.6% |
| 0 | 229512 | 6.6% |
| . | 218260 | 6.3% |
| 1 | 151628 | 4.4% |
| M | 130243 | 3.8% |
| l | 126499 | 3.7% |
| o | 123840 | 3.6% |
| 5 | 98076 | 2.8% |
| a | 89543 | 2.6% |
| Other values (51) | 1209798 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1180892 | |
| Space Separator | 781390 | |
| Decimal Number | 665363 | |
| Uppercase Letter | 547937 | |
| Other Punctuation | 242207 | 7.0% |
| Open Punctuation | 17241 | 0.5% |
| Close Punctuation | 17241 | 0.5% |
| Dash Punctuation | 1435 | < 0.1% |
| Math Symbol | 1325 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 296242 | |
| l | 126499 | |
| o | 123840 | |
| a | 89543 | 7.6% |
| m | 78163 | 6.6% |
| t | 64626 | 5.5% |
| r | 59007 | 5.0% |
| i | 57804 | 4.9% |
| s | 51354 | 4.3% |
| f | 43405 | 3.7% |
| Other values (14) | 190409 |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 130243 | |
| W | 86225 | |
| C | 66603 | |
| R | 60325 | |
| D | 58884 | |
| S | 29264 | 5.3% |
| A | 28621 | 5.2% |
| N | 23713 | 4.3% |
| H | 15066 | 2.7% |
| V | 14694 | 2.7% |
| Other values (9) | 34299 | 6.3% |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 229512 | |
| 1 | 151628 | |
| 5 | 98076 | |
| 2 | 69262 | 10.4% |
| 3 | 41831 | 6.3% |
| 4 | 28717 | 4.3% |
| 6 | 19501 | 2.9% |
| 9 | 10091 | 1.5% |
| 7 | 9433 | 1.4% |
| 8 | 7312 | 1.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 218260 | |
| , | 15806 | 6.5% |
| & | 8141 | 3.4% |
Space Separator
| Value | Count | Frequency (%) |
| 781390 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 17241 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 17241 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 1435 |
Math Symbol
| Value | Count | Frequency (%) |
| + | 1325 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1728829 | |
| Common | 1726202 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 296242 | |
| M | 130243 | 7.5% |
| l | 126499 | 7.3% |
| o | 123840 | 7.2% |
| a | 89543 | 5.2% |
| W | 86225 | 5.0% |
| m | 78163 | 4.5% |
| C | 66603 | 3.9% |
| t | 64626 | 3.7% |
| R | 60325 | 3.5% |
| Other values (33) | 606520 |
Common
| Value | Count | Frequency (%) |
| 781390 | ||
| 0 | 229512 | 13.3% |
| . | 218260 | 12.6% |
| 1 | 151628 | 8.8% |
| 5 | 98076 | 5.7% |
| 2 | 69262 | 4.0% |
| 3 | 41831 | 2.4% |
| 4 | 28717 | 1.7% |
| 6 | 19501 | 1.1% |
| ( | 17241 | 1.0% |
| Other values (8) | 70784 | 4.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3455031 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 781390 | ||
| e | 296242 | 8.6% |
| 0 | 229512 | 6.6% |
| . | 218260 | 6.3% |
| 1 | 151628 | 4.4% |
| M | 130243 | 3.8% |
| l | 126499 | 3.7% |
| o | 123840 | 3.6% |
| 5 | 98076 | 2.8% |
| a | 89543 | 2.6% |
| Other values (51) | 1209798 |
Collection
Categorical
| Distinct | 14 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| d. Gift Pack | |
|---|---|
| g. Premium Deo | |
| a. Classic 100 ml | |
| f. Classic 20 ml | |
| e. Aqua | |
| Other values (9) |
Length
| Max length | 17 |
|---|---|
| Median length | 15 |
| Mean length | 13.892183 |
| Min length | 7 |
Characters and Unicode
| Total characters | 2732509 |
|---|---|
| Distinct characters | 41 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | g. Premium Deo |
|---|---|
| 2nd row | f. Classic 20 ml |
| 3rd row | g. Escapade Deo |
| 4th row | I. Tales 100ml |
| 5th row | a. Classic 100 ml |
Common Values
| Value | Count | Frequency (%) |
| d. Gift Pack | 33257 | |
| g. Premium Deo | 33186 | |
| a. Classic 100 ml | 32271 | |
| f. Classic 20 ml | 28312 | |
| e. Aqua | 17234 | |
| g. Escapade Deo | 14175 | |
| b. Classic 50 ml | 12523 | 6.4% |
| c. Escapade | 10201 | 5.2% |
| j1. Nox 100 ml | 6358 | 3.2% |
| I. Tales 100ml | 6183 | 3.1% |
| Other values (4) | 2994 | 1.5% |
Length
| Value | Count | Frequency (%) |
| ml | 79464 | |
| classic | 73106 | 11.4% |
| g | 47361 | 7.4% |
| deo | 47361 | 7.4% |
| 100 | 38629 | 6.0% |
| d | 33257 | 5.2% |
| pack | 33257 | 5.2% |
| gift | 33257 | 5.2% |
| premium | 33186 | 5.2% |
| a | 32271 | 5.0% |
| Other values (21) | 192252 |
Most occurring characters
| Value | Count | Frequency (%) |
| 446707 | ||
| a | 214645 | 7.9% |
| . | 196694 | 7.2% |
| s | 177619 | 6.5% |
| l | 167082 | 6.1% |
| m | 154165 | 5.6% |
| c | 141788 | 5.2% |
| i | 139553 | 5.1% |
| 0 | 134743 | 4.9% |
| e | 128344 | 4.7% |
| Other values (31) | 831169 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1572431 | |
| Space Separator | 446707 | 16.3% |
| Uppercase Letter | 285641 | 10.5% |
| Decimal Number | 231032 | 8.5% |
| Other Punctuation | 196694 | 7.2% |
| Dash Punctuation | 4 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 214645 | |
| s | 177619 | |
| l | 167082 | |
| m | 154165 | |
| c | 141788 | |
| i | 139553 | |
| e | 128344 | |
| f | 61569 | 3.9% |
| d | 57637 | 3.7% |
| o | 55869 | 3.6% |
| Other values (12) | 274160 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 73106 | |
| P | 66443 | |
| D | 47361 | |
| G | 33257 | |
| E | 24376 | 8.5% |
| A | 17234 | 6.0% |
| N | 8500 | 3.0% |
| I | 6183 | 2.2% |
| T | 6183 | 2.2% |
| W | 2142 | 0.7% |
| Other values (2) | 856 | 0.3% |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 134743 | |
| 1 | 53312 | 23.1% |
| 2 | 30454 | 13.2% |
| 5 | 12523 | 5.4% |
Space Separator
| Value | Count | Frequency (%) |
| 446707 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 196694 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 4 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1858072 | |
| Common | 874437 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 214645 | |
| s | 177619 | 9.6% |
| l | 167082 | 9.0% |
| m | 154165 | 8.3% |
| c | 141788 | 7.6% |
| i | 139553 | 7.5% |
| e | 128344 | 6.9% |
| C | 73106 | 3.9% |
| P | 66443 | 3.6% |
| f | 61569 | 3.3% |
| Other values (24) | 533758 |
Common
| Value | Count | Frequency (%) |
| 446707 | ||
| . | 196694 | |
| 0 | 134743 | 15.4% |
| 1 | 53312 | 6.1% |
| 2 | 30454 | 3.5% |
| 5 | 12523 | 1.4% |
| - | 4 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2732509 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 446707 | ||
| a | 214645 | 7.9% |
| . | 196694 | 7.2% |
| s | 177619 | 6.5% |
| l | 167082 | 6.1% |
| m | 154165 | 5.6% |
| c | 141788 | 5.2% |
| i | 139553 | 5.1% |
| 0 | 134743 | 4.9% |
| e | 128344 | 4.7% |
| Other values (31) | 831169 |
| Year | Month | Month Key | QTR | Region | Invoice Date | Material | Quantity | Gender | Brand | Channel | Franchisee store | Bill to Party code | Bill to Party Name | MRP | Gross UCP | Net UCP | Bill to Party City | ShiptopartyStateCode | Billing grp | Channel-1 | Variant Name | Collection | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2022-23 | 2022-04-01 | Apr | Q1 | South | 2022-04-01 | NFM03DQ1 | 4 | G | TF | CN | CN1200 | CN1200 | CT-BENGALURU-RESIDENCYROAD | 499 | 1996 | 1996.0 | Bangalore | KARNATAKA | LFS | LFS | 3. 150 M Amalfi Men deo | g. Premium Deo |
| 1 | 2022-23 | 2022-04-01 | Apr | Q1 | South | 2022-04-01 | NDFM13PD1 | 1 | G | TF | CN | CN1201 | CN1201 | CT-HYDERABAD-G.S.CENTERPOINT | 595 | 595 | 595.0 | Hyderabad | TELANGANA | LFS | LFS | 3. 20 M Verge | f. Classic 20 ml |
| 2 | 2022-23 | 2022-04-01 | Apr | Q1 | South | 2022-04-01 | NFM05DQ1 | 1 | G | TF | CN | CN1201 | CN1201 | CT-HYDERABAD-G.S.CENTERPOINT | 499 | 499 | 499.0 | Hyderabad | TELANGANA | LFS | LFS | 8. Deo M C. Road 150 ml | g. Escapade Deo |
| 3 | 2022-23 | 2022-04-01 | Apr | Q1 | West | 2022-04-01 | FW19PC1 | 1 | L | TF | CN | CN1206 | CN1206 | CT-MUMBAI-GOREGAON-OBEROIMALL | 1595 | 1595 | 1595.0 | Mumbai | MAHARASTRA | LFS | LFS | 3. Tales W Ibiza 100 ml | I. Tales 100ml |
| 4 | 2022-23 | 2022-04-01 | Apr | Q1 | South | 2022-04-01 | NEFW05PGC | 1 | L | TF | CN | CN1212 | CN1212 | CT-BENGALURU-J.P.NAGAR | 2295 | 2295 | 2295.0 | Bangalore | KARNATAKA | LFS | LFS | 7. 100 W Pristine | a. Classic 100 ml |
| 5 | 2022-23 | 2022-04-01 | Apr | Q1 | South | 2022-04-01 | NFM01DQ1 | 1 | G | TF | CN | CN1212 | CN1212 | CT-BENGALURU-J.P.NAGAR | 499 | 499 | 499.0 | Bangalore | KARNATAKA | LFS | LFS | 1. 150 M Raw Deo | g. Premium Deo |
| 6 | 2022-23 | 2022-04-01 | Apr | Q1 | South | 2022-04-01 | NFFM05PG2 | 1 | G | TF | CN | CN1212 | CN1212 | CT-BENGALURU-J.P.NAGAR | 1995 | 1995 | 1995.0 | Bangalore | KARNATAKA | LFS | LFS | 2. Mini 25 ml M (R,V) | d. Gift Pack |
| 7 | 2022-23 | 2022-04-01 | Apr | Q1 | West | 2022-04-01 | NFM02DQ1 | 1 | G | TF | CN | CN1231 | CN1231 | CT-PIMPRI-CITYCENTREMALL | 499 | 499 | 499.0 | Pune | MAHARASTRA | LFS | LFS | 2. 150 M Steele Deo | g. Premium Deo |
| 8 | 2022-23 | 2022-04-01 | Apr | Q1 | West | 2022-04-01 | NFW02DQ1 | 1 | L | TF | CN | CN1231 | CN1231 | CT-PIMPRI-CITYCENTREMALL | 499 | 499 | 499.0 | Pune | MAHARASTRA | LFS | LFS | 5. 150 W Nude Deo | g. Premium Deo |
| 9 | 2022-23 | 2022-04-01 | Apr | Q1 | North | 2022-04-01 | NEFM01PGC | 1 | G | TF | CN | CN1239 | CN1239 | CT-NEWDELHI-WORLDMARK | 2295 | 2295 | 1951.0 | Delhi | DELHI | LFS | LFS | 1. 100 M Raw | a. Classic 100 ml |
| Year | Month | Month Key | QTR | Region | Invoice Date | Material | Quantity | Gender | Brand | Channel | Franchisee store | Bill to Party code | Bill to Party Name | MRP | Gross UCP | Net UCP | Bill to Party City | ShiptopartyStateCode | Billing grp | Channel-1 | Variant Name | Collection | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 846925 | 2022-23 | 2023-03-01 | Mar | Q4 | West | 2023-03-31 | NEFW12PD1 | 1 | L | TF | CT | CT0031 | CT0031 | CT-NASHIK-CITY CENTER-LAWATE N | 645 | 645 | 645.0 | Nashik | MAHARASTRA | LFS | LFS | 5. 20 W Nude | f. Classic 20 ml |
| 846926 | 2022-23 | 2023-03-01 | Mar | Q4 | South | 2023-03-31 | NGFM08PC1 | 1 | G | TF | CT | CT0019 | CT0019 | CT-THIRUVANANTHAPURAM-ARTECH W-TRIVENDRUM | 2695 | 2695 | 2695.0 | Thiruvananthapuram | Kerala | LFS | LFS | 2. 100 M C.Road | c. Escapade |
| 846927 | 2022-23 | 2023-03-01 | Mar | Q4 | South | 2023-03-31 | NFM01DQ1 | 1 | G | TF | CT | CT0014 | CT0014 | CT-BENGALURU-SOUL SPACE SPIRIT | 499 | 499 | 499.0 | Bangalore | KARNATAKA | LFS | LFS | 1. 150 M Raw Deo | g. Premium Deo |
| 846928 | 2022-23 | 2023-03-01 | Mar | Q4 | South | 2023-03-31 | NEFW13PD1 | 1 | L | TF | CT | CT0014 | CT0014 | CT-BENGALURU-SOUL SPACE SPIRIT | 645 | 645 | 645.0 | Bangalore | KARNATAKA | LFS | LFS | 6. 20 W Sheer | f. Classic 20 ml |
| 846929 | 2022-23 | 2023-03-01 | Mar | Q4 | South | 2023-03-31 | NFFM14PK1 | 1 | G | TF | CT | CT0014 | CT0014 | CT-BENGALURU-SOUL SPACE SPIRIT | 2795 | 2795 | 2795.0 | Bangalore | KARNATAKA | LFS | LFS | 2. Aqua M 90 ml | e. Aqua |
| 846930 | 2022-23 | 2023-03-01 | Mar | Q4 | South | 2023-03-31 | NFFW01CL2 | 1 | L | TF | CT | CT0014 | CT0014 | CT-BENGALURU-SOUL SPACE SPIRIT | 1995 | 1995 | 1995.0 | Bangalore | KARNATAKA | LFS | LFS | 6. Coffret Deo W Celeste | d. Gift Pack |
| 846931 | 2022-23 | 2023-03-01 | Mar | Q4 | South | 2023-03-31 | NFFP01PG2 | 1 | U | TF | CT | CT0014 | CT0014 | CT-BENGALURU-SOUL SPACE SPIRIT | 1995 | 1995 | 1995.0 | Bangalore | KARNATAKA | LFS | LFS | 4. His & Her Mini 25 ml (V,S) | d. Gift Pack |
| 846932 | 2022-23 | 2023-03-01 | Mar | Q4 | South | 2023-03-31 | NFM05DQ1 | 1 | G | TF | CT | CT0014 | CT0014 | CT-BENGALURU-SOUL SPACE SPIRIT | 499 | 499 | 499.0 | Bangalore | KARNATAKA | LFS | LFS | 8. Deo M C. Road 150 ml | g. Escapade Deo |
| 846933 | 2022-23 | 2023-03-01 | Mar | Q4 | South | 2023-03-31 | FW24PC1 | 1 | L | TF | CT | CT0014 | CT0014 | CT-BENGALURU-SOUL SPACE SPIRIT | 3995 | 3995 | 3495.0 | Bangalore | KARNATAKA | LFS | LFS | 2. Nox W 100 ml | j1. Nox 100 ml |
| 846934 | 2022-23 | 2023-03-01 | Mar | Q4 | North | 2023-03-31 | NFFM04PGC | 1 | G | TF | CT | CT0006 | CT0006 | CT-NOIDA-GREAT INDIA PLACE | 2595 | 2595 | 2595.0 | Noida | UTTARPRADESH | LFS | LFS | 3. 100 M Verge | a. Classic 100 ml |
Most frequently occurring
| Year | Month | Month Key | QTR | Region | Invoice Date | Material | Quantity | Gender | Brand | Channel | Franchisee store | Bill to Party code | Bill to Party Name | MRP | Gross UCP | Net UCP | Bill to Party City | ShiptopartyStateCode | Billing grp | Channel-1 | Variant Name | Collection | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2022-23 | 2022-04-01 | Apr | Q1 | East | 2022-04-10 | NEFM02PFC | 1 | G | TF | SS | SS221 | SS221 | 112-SSL-ELGINROADKOLKATA | 2295 | 2295 | 2295.00 | Kolkata | WESTBENGAL | LFS | LFS | 2. 100 M Steele | a. Classic 100 ml | 2 |
| 1 | 2022-23 | 2022-04-01 | Apr | Q1 | East | 2022-04-15 | NEFW14PD1 | 1 | L | TF | SS | SS283 | SS283 | 188-SSL-ACROPOLISKOLKATA | 645 | 645 | 503.49 | Kolkata | WESTBENGAL | LFS | LFS | 7. 20 W Pristine | f. Classic 20 ml | 2 |
| 2 | 2022-23 | 2022-04-01 | Apr | Q1 | East | 2022-04-28 | NEFW11PD1 | 1 | L | TF | SS | SS283 | SS283 | 188-SSL-ACROPOLISKOLKATA | 645 | 645 | 645.00 | Kolkata | WESTBENGAL | LFS | LFS | 4. 20 W Celeste | f. Classic 20 ml | 2 |
| 3 | 2022-23 | 2022-04-01 | Apr | Q1 | North | 2022-04-01 | NEFW02PFC | 1 | L | TF | SS | SS216 | SS216 | 121-SSL-LUCKNOW | 2295 | 2295 | 2295.00 | Lucknow | UTTARPRADESH | LFS | LFS | 4. 100 W Celeste | a. Classic 100 ml | 2 |
| 4 | 2022-23 | 2022-04-01 | Apr | Q1 | North | 2022-04-02 | NFM01DQ1 | 1 | G | TF | SS | SS309 | SS309 | 478-SHOPPERSSTOP-TAPASYAONE | 499 | 499 | 499.00 | Gurgaon | HARYANA | LFS | LFS | 1. 150 M Raw Deo | g. Premium Deo | 2 |
| 5 | 2022-23 | 2022-04-01 | Apr | Q1 | North | 2022-04-03 | NEFP01PGFL | 1 | P | TF | SS | SS216 | SS216 | 121-SSL-LUCKNOW | 2695 | 2695 | 2695.00 | Lucknow | UTTARPRADESH | LFS | LFS | 1. His & Her 50 ml (R,C) | d. Gift Pack | 2 |
| 6 | 2022-23 | 2022-04-01 | Apr | Q1 | North | 2022-04-04 | FM01HQ2 | 1 | G | TF | SS | SS282 | SS282 | 267-SSL-JANAKPURI | 1845 | 1845 | 1845.00 | Delhi | DELHI | LFS | LFS | 10. Amalfi Coffret M EDP + Deo | d. Gift Pack | 2 |
| 7 | 2022-23 | 2022-04-01 | Apr | Q1 | South | 2022-04-05 | NEFP01PGFL | 1 | P | TF | SS | SS227 | SS227 | 154-SSL-CYBERABADINORBIT | 2695 | 2695 | 2695.00 | Hyderabad | TELANGANA | LFS | LFS | 1. His & Her 50 ml (R,C) | d. Gift Pack | 2 |
| 8 | 2022-23 | 2022-04-01 | Apr | Q1 | South | 2022-04-28 | NEFM01PGL | 1 | G | TF | SS | SS242 | SS242 | 161-SSL-MYSORE | 1595 | 1595 | 1595.00 | Mysore | KARNATAKA | LFS | LFS | 1. 50 M Raw | b. Classic 50 ml | 2 |
| 9 | 2022-23 | 2022-05-01 | May | Q1 | East | 2022-05-02 | FM21PC1 | 1 | G | TF | SS | SS303 | SS303 | 314-SSL-GUWAHATICITYCENTER | 3995 | 3995 | 3995.00 | Guwahati | WESTBENGAL | LFS | LFS | 1. Nox M 100 ml | j1. Nox 100 ml | 2 |